﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace LogicUniversityBiz
{
    public class CoreSupervisorFascade
    {
        private LogicUniversityEntities contextDB = new LogicUniversityEntities();

        public static EFFascade getEFFascade()
        {
            return new EFFascade();
        }

        //to retrieve all catelogue
        public List<Catelogue> getAllCatelogue()
        {
            var query = from c in contextDB.Catelogues
                        select c;

            return query.ToList();
        }

        public List<String> getAllCategory()
        {
            var query = from c in contextDB.Catelogues
                        select c.Category;

            return query.ToList();
        }
    }
}
